/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : localhost:3306
 Source Schema         : sc_platform

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 10/07/2020 14:12:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_db
-- ----------------------------
DROP TABLE IF EXISTS `sys_db`;
CREATE TABLE `sys_db` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '主键',
  `db_type` varchar(15) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据库类型',
  `host` int(15) DEFAULT NULL COMMENT '数据库地址',
  `port` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据库端口',
  `db_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据库名称',
  `username` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户名',
  `password` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='数据库管理';

-- ----------------------------
-- Records of sys_db
-- ----------------------------
BEGIN;
INSERT INTO `sys_db` VALUES ('1', 'MySQL', 127, '3306', 'pre', 'root', 'root', '2019-04-27 08:42:41', NULL);
INSERT INTO `sys_db` VALUES ('2', 'MySQL', 127, '3306', 'pre', 'root', 'root', '2019-05-13 17:10:54', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '部门主键ID',
  `name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除  -1：已删除  0：正常',
  `parent_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '上级部门',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='部门管理';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES ('12', '市场部', 0, 0, '5', '2019-04-30 14:31:46', '2019-04-30 14:47:44');
INSERT INTO `sys_dept` VALUES ('1268098678998016002', 'qqqzzzc', 0, 0, '0', '2020-06-03 16:34:19', '2020-06-12 00:41:55');
INSERT INTO `sys_dept` VALUES ('1268098729019285506', 'aaa', 0, 0, '0', '2020-06-03 16:34:31', '2020-06-03 16:34:31');
INSERT INTO `sys_dept` VALUES ('1268098774829473794', 'aaa', 0, 1, '1268098678998016002', '2020-06-03 16:34:42', '2020-06-03 03:35:22');
INSERT INTO `sys_dept` VALUES ('1271316817307054082', 'ccccc', 0, 1, '1268098678998016002', '2020-06-12 13:42:03', '2020-06-12 00:42:07');
INSERT INTO `sys_dept` VALUES ('4', '某某集团', 0, 0, '0', '2019-04-21 22:53:33', '2019-04-30 22:27:59');
INSERT INTO `sys_dept` VALUES ('5', '上海公司', 0, 0, '4', '2019-04-21 22:53:57', '2019-05-03 10:09:18');
INSERT INTO `sys_dept` VALUES ('6', '研发部', 0, 0, '5', '2019-04-21 22:54:10', '2019-04-24 08:03:08');
INSERT INTO `sys_dept` VALUES ('7', '财务部', 0, 0, '5', '2019-04-21 22:54:46', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` varchar(20) NOT NULL COMMENT '编号',
  `value` varchar(100) DEFAULT NULL COMMENT '数据值',
  `label` varchar(100) DEFAULT NULL COMMENT '标签名',
  `name` varchar(100) NOT NULL COMMENT '名称',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  `sort` int(4) DEFAULT NULL COMMENT '排序（升序）',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注信息',
  `del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `sys_dict_value` (`value`),
  KEY `sys_dict_label` (`label`),
  KEY `sys_dict_del_flag` (`del_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES ('10', 'lock_flag_1', '锁定', 'lock_flag', NULL, 0, NULL, 0, '2019-06-03 20:53:24', '2020-06-11 10:43:18');
INSERT INTO `sys_dict` VALUES ('1271341031040753665', NULL, NULL, '11', '2211', 0, '111222', 1, '2020-06-12 15:18:16', '2020-06-12 15:21:13');
INSERT INTO `sys_dict` VALUES ('1271341836896673794', '2222', '22', '11', NULL, 0, NULL, 1, '2020-06-12 15:21:28', '2020-06-12 15:21:28');
INSERT INTO `sys_dict` VALUES ('1271341884732710914', '333', '33', '11', NULL, 0, NULL, 1, '2020-06-12 15:21:40', '2020-06-12 15:21:40');
INSERT INTO `sys_dict` VALUES ('1271342206024785921', '444', '44', '11', NULL, 0, NULL, 1, '2020-06-12 15:22:56', '2020-06-12 15:22:56');
INSERT INTO `sys_dict` VALUES ('4', NULL, NULL, 'del_flag', '用户状态', NULL, '用户状态', 0, '2019-05-26 15:13:55', '2020-06-03 15:55:09');
INSERT INTO `sys_dict` VALUES ('5', NULL, NULL, 'lock_flag', '用户锁定状态', NULL, '用户锁定状态', 0, '2020-06-11 10:42:32', '2020-06-11 10:42:42');
INSERT INTO `sys_dict` VALUES ('7', 'del_flag_0', '正常', 'del_flag', NULL, 1, NULL, 0, '2019-06-03 20:53:24', '2020-06-03 15:55:37');
INSERT INTO `sys_dict` VALUES ('8', 'del_flag_1', '删除', 'del_flag', NULL, 0, NULL, 0, '2019-06-07 20:43:29', '2020-06-03 15:55:42');
INSERT INTO `sys_dict` VALUES ('9', 'lock_flag_0', '正常', 'lock_flag', NULL, 1, NULL, 0, '2019-06-03 20:53:24', '2020-06-11 10:43:13');
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '主键',
  `job_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '岗位名称',
  `dept_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门id',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `del_flag` tinyint(1) DEFAULT NULL COMMENT '是否删除  -1：已删除  0：正常',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='岗位管理';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` VALUES ('1', 'L董事长', '4', 0, 0, '2019-05-03 09:43:56', NULL);
INSERT INTO `sys_job` VALUES ('1268099929718497281', '嗷嗷', '4', 0, 0, '2020-06-03 16:39:18', NULL);
INSERT INTO `sys_job` VALUES ('1268100904529186817', 'zzz', '4', 0, 0, '2020-06-03 16:43:10', NULL);
INSERT INTO `sys_job` VALUES ('1268100916206129153', 'aaac', '4', 0, 1, '2020-06-03 16:43:13', NULL);
INSERT INTO `sys_job` VALUES ('1268100946505781249', 'ccc', '4', 0, 0, '2020-06-03 16:43:20', NULL);
INSERT INTO `sys_job` VALUES ('1271316890522824705', 'aaav', '1268098678998016002', 0, 1, '2020-06-12 13:42:21', NULL);
INSERT INTO `sys_job` VALUES ('3', '全栈开发', '6', 1, 0, '2019-05-03 10:31:03', NULL);
INSERT INTO `sys_job` VALUES ('4', '软件测试', '6', 2, 0, '2019-05-03 10:31:41', NULL);
INSERT INTO `sys_job` VALUES ('5', '财务总监', '7', 3, 0, '2019-06-16 00:44:59', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '主键',
  `request_ip` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '操作IP',
  `type` int(3) DEFAULT NULL COMMENT '操作类型 1 操作记录2异常记录',
  `user_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '操作人',
  `description` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '操作描述',
  `action_method` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '请求方法',
  `action_url` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `params` varchar(1000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '请求参数',
  `ua` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '浏览器',
  `class_path` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '类路径',
  `request_method` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '请求方法',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '开始时间',
  `finish_time` timestamp NULL DEFAULT NULL COMMENT '完成时间',
  `consuming_time` bigint(11) DEFAULT NULL COMMENT '消耗时间',
  `ex_desc` varchar(1000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '异常详情信息',
  `ex_detail` text COLLATE utf8mb4_bin COMMENT '异常描述',
  `del_flag` tinyint(1) DEFAULT NULL COMMENT '是否删除  -1：已删除  0：正常',
  PRIMARY KEY (`id`),
  KEY `index_type` (`type`) USING BTREE COMMENT '日志类型'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES ('12', '0:0:0:0:0:0:0:1', 2, '1', '修改菜单', 'updateMenu', '/menu', '[MenuDto(menuId=13, name=角色管理, perms=, url=, parentId=1, icon=peoples, sort=0, type=1, delFlag=0)]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysMenuController', 'PUT', '2019-04-29 21:08:40', '2019-04-29 21:08:40', 1, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('1271349170058371073', '127.0.0.1', 1, 'admin', '更新岗位', 'update', '/sysJob/update', '{\"deptId\":\"4\",\"deptName\":\"某某集团\",\"id\":\"1\",\"jobName\":\"L董事长\",\"sort\":0}', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', 'com.xyw.code.platform.webapps.rest.SysJobController', 'PUT', '2020-06-12 02:50:21', '2020-06-12 02:50:27', 6662, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('13', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/7', '[7]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:15:34', '2019-04-29 21:15:34', 3, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('14', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/5', '[5]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:15:37', '2019-04-29 21:15:37', 0, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('15', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/8', '[8]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:15:39', '2019-04-29 21:15:39', 0, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('16', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/5', '[5]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:17:30', '2019-04-29 21:17:30', 0, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('17', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/8', '[8]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:17:39', '2019-04-29 21:17:39', 0, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('18', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/8', '[8]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:17:46', '2019-04-29 21:17:46', 1, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('19', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/5', '[5]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:18:05', '2019-04-29 21:18:05', 0, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('20', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/8', '[8]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:18:10', '2019-04-29 21:18:10', 0, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('21', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/8', '[8]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:18:16', '2019-04-29 21:18:16', 0, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('22', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/8', '[8]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:19:08', '2019-04-29 21:19:08', 1, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('23', '0:0:0:0:0:0:0:1', 1, '1', '更新角色以及菜单权限', 'update', '/role', '[RoleDto(roleId=8, roleName=测试人员, roleCode=TEST_ROLE, roleDesc=测试人员, delFlag=0, roleMenus=[SysRoleMenu(id=null, roleId=8, menuId=6), SysRoleMenu(id=null, roleId=8, menuId=7), SysRoleMenu(id=null, roleId=8, menuId=8), SysRoleMenu(id=null, roleId=8, menuId=9)])]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'PUT', '2019-04-29 21:19:11', '2019-04-29 21:19:11', 0, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('24', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/8', '[8]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:19:13', '2019-04-29 21:19:13', 1, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('25', '0:0:0:0:0:0:0:1', 1, '1', '据角色id获取菜单', 'findRoleMenus', '/role/findRoleMenus/8', '[8]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysRoleController', 'GET', '2019-04-29 21:20:21', '2019-04-29 21:20:21', 18, NULL, NULL, 0);
INSERT INTO `sys_log` VALUES ('9', '0:0:0:0:0:0:0:1', 1, '1', '修改菜单', 'updateMenu', '/menu', '[MenuDto(menuId=2, name=用户管理, perms=, url=ces, parentId=1, icon=user, sort=0, type=1, delFlag=0)]', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36', 'com.xd.pre.controller.SysMenuController', 'PUT', '2019-04-29 21:07:37', '2019-04-29 21:07:37', 1, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单ID',
  `name` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单名称',
  `url` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '网站url  如果是菜单或者目录则为空',
  `perms` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '菜单权限标识',
  `path` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '前端跳转URL',
  `method` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'POST/GET/DELETE/PUT',
  `component` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '菜单组件',
  `parent_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '父菜单ID',
  `icon` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图标',
  `sort` int(11) DEFAULT '1' COMMENT '排序',
  `type` tinyint(1) DEFAULT NULL COMMENT '菜单类型 （类型   0：目录   1：菜单   2：按钮）',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '逻辑删除标记(0--正常 1--删除)',
  `is_frame` tinyint(1) DEFAULT NULL COMMENT '是否为外链(1:不是外链  0是外链)',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1', '权限管理', NULL, NULL, 'admin', 'GET', '', '0', 'authority', 0, 0, 0, 1, '2019-04-21 22:45:08', '2020-05-28 08:09:05');
INSERT INTO `sys_menu` VALUES ('11', '部门新增', '/sysDict/add', 'sys:dept:add', NULL, 'POST', NULL, '3', '', 0, 2, 0, 1, '2019-04-25 11:09:50', '2020-05-28 08:23:54');
INSERT INTO `sys_menu` VALUES ('1271321271540461570', '测试管理', NULL, '', 'test', 'POST', '', '0', '404', 0, 0, 0, 1, '2020-06-12 13:59:45', '2020-06-12 14:00:31');
INSERT INTO `sys_menu` VALUES ('1271322754440835074', '测试1', NULL, 'admin/menu', 'menu', 'GET', 'admin/menu ', '1271321271540461570', 'authority', 0, 1, 0, 1, '2020-06-12 14:05:39', '2020-06-12 14:17:11');
INSERT INTO `sys_menu` VALUES ('13', '角色管理', NULL, NULL, 'role', 'GET', 'admin/role', '1', 'peoples', 1, 1, 0, 1, '2019-04-29 21:08:28', '2020-05-28 08:09:20');
INSERT INTO `sys_menu` VALUES ('14', '用户修改', '/sysUser/update', 'sys:user:update', NULL, 'PUT', NULL, '2', NULL, 0, 2, 0, 1, '2019-04-30 23:43:31', '2020-05-28 08:21:49');
INSERT INTO `sys_menu` VALUES ('15', '角色新增', '/sysRole/add', 'sys:role:add', NULL, 'POST', NULL, '13', '', 0, 2, 0, 1, '2019-05-01 08:49:21', '2020-05-28 08:24:59');
INSERT INTO `sys_menu` VALUES ('16', '菜单管理', NULL, NULL, 'menu', 'GET', 'admin/menu', '1', 'menu', 3, 1, 0, 1, '2019-05-03 15:26:58', '2020-05-28 08:09:23');
INSERT INTO `sys_menu` VALUES ('17', '岗位管理', NULL, NULL, 'job', 'GET', 'admin/job', '1', 'job', 4, 1, 0, 1, '2019-05-03 15:27:25', '2020-05-28 08:09:21');
INSERT INTO `sys_menu` VALUES ('18', '异常日志', NULL, NULL, 'erlog', 'GET', 'sys/errorlog', '6', 'erlog', 1, 1, 0, 1, '2019-05-03 23:00:54', '2020-05-28 08:09:47');
INSERT INTO `sys_menu` VALUES ('2', '用户管理', NULL, NULL, 'user', 'GET', 'admin/user', '1', 'user', 1, 1, 0, 1, '2019-04-21 22:49:22', '2020-05-28 08:09:09');
INSERT INTO `sys_menu` VALUES ('25', '日志查看', '/sysLog/query', 'sys:log:list', '', 'GET', '', '18', '', 0, 2, 0, 1, '2019-05-06 22:46:13', '2020-05-28 08:26:07');
INSERT INTO `sys_menu` VALUES ('26', '日志删除', '/sysLog/delete/{id}', 'sys:log:delete', '', 'DELETE', '', '18', '', 0, 2, 0, 1, '2019-05-06 22:46:47', '2020-05-28 08:26:15');
INSERT INTO `sys_menu` VALUES ('28', '菜单增加', '/sysMenu/add', 'sys:menu:add', NULL, 'POST', '', '16', '', 0, 2, 0, 1, '2019-05-08 16:09:43', '2020-05-28 08:28:06');
INSERT INTO `sys_menu` VALUES ('29', '菜单修改', '/sysMenu/update', 'sys:menu:update', NULL, 'PUT', '', '16', '', 0, 2, 0, 1, '2019-05-08 16:10:06', '2020-05-28 08:28:02');
INSERT INTO `sys_menu` VALUES ('3', '部门管理', NULL, NULL, 'dept', 'GET', 'admin/dept', '1', 'dept', 2, 1, 0, 1, '2019-04-21 22:52:11', '2020-05-28 08:09:18');
INSERT INTO `sys_menu` VALUES ('30', '部门修改', '/sysDict/update', 'sys:dept:update', NULL, 'PUT', NULL, '3', '', 0, 2, 0, 1, '2019-05-08 23:49:54', '2020-05-28 08:23:57');
INSERT INTO `sys_menu` VALUES ('31', '部门删除', '/sysDict/delete/{id}', 'sys:dept:delete', NULL, 'DELETE', NULL, '3', '', 0, 2, 0, 1, '2019-05-08 23:53:41', '2020-05-28 08:24:10');
INSERT INTO `sys_menu` VALUES ('32', '日志批量删除', '/sysLog/delete', 'sys:log:delete', '', 'DELETE', '', '18', '', 0, 2, 0, 1, '2019-05-10 13:58:52', '2020-05-28 08:27:16');
INSERT INTO `sys_menu` VALUES ('33', '用户查看', '/sysUser/get/{id}', 'sys:user:view', NULL, 'GET', NULL, '2', NULL, 0, 2, 0, 1, '2019-05-12 18:59:46', '2020-05-28 08:21:51');
INSERT INTO `sys_menu` VALUES ('34', '角色修改', '/sysRole/update', 'sys:role:update', NULL, 'PUT', NULL, '13', '', 0, 2, 0, 1, '2019-05-12 19:05:03', '2020-05-28 08:25:03');
INSERT INTO `sys_menu` VALUES ('35', '用户删除', '/sysUser/delete/{id}', 'sys:user:delete', NULL, 'DELETE', NULL, '2', NULL, 0, 2, 0, 1, '2019-05-12 19:08:13', '2020-05-28 08:21:53');
INSERT INTO `sys_menu` VALUES ('36', '菜单删除', '/sysMenu/delete/{id}', 'sys:menu:delete', NULL, 'DELETE', '', '16', '', 0, 2, 0, 1, '2019-05-12 19:10:02', '2020-05-28 08:27:59');
INSERT INTO `sys_menu` VALUES ('37', '角色删除', '/sysRole/delete/{id}', 'sys:role:delete', NULL, 'DELETE', NULL, '13', '', 0, 2, 0, 1, '2019-05-12 19:11:14', '2020-05-28 08:25:09');
INSERT INTO `sys_menu` VALUES ('38', '角色查看', '/sysRole/query', 'sys:role:list', NULL, 'GET', NULL, '13', '', 0, 2, 0, 1, '2019-05-12 19:11:37', '2020-05-28 08:25:22');
INSERT INTO `sys_menu` VALUES ('39', '岗位新增', '/sysJob/add', 'sys:job:add', NULL, 'POST', '', '17', '', 0, 2, 0, 1, '2019-05-12 19:15:57', '2020-05-28 08:28:54');
INSERT INTO `sys_menu` VALUES ('40', '岗位修改', '/sysJob/update', 'sys:job:update', NULL, 'PUT', '', '17', '', 0, 2, 0, 1, '2019-05-12 19:16:30', '2020-05-28 08:28:56');
INSERT INTO `sys_menu` VALUES ('41', '岗位查看', '/sysJob/query', 'sys:job:list', NULL, 'GET', '', '17', '', 0, 2, 0, 1, '2019-05-12 19:16:44', '2020-05-28 08:29:01');
INSERT INTO `sys_menu` VALUES ('42', '岗位删除', '/sysJob/delete/{id}', 'sys:job:delete', NULL, 'DELETE', '', '17', '', 0, 2, 0, 1, '2019-05-12 19:17:16', '2020-05-28 08:29:07');
INSERT INTO `sys_menu` VALUES ('43', '字典管理', NULL, NULL, 'dict', 'GET', 'admin/dict', '1', 'tag', 5, 1, 0, 1, '2019-05-16 18:17:32', '2020-05-28 08:09:52');
INSERT INTO `sys_menu` VALUES ('44', '部门查看', '/sysDict/query', 'sys:dept:list', NULL, 'GET', NULL, '3', '', 0, 2, 0, 1, '2019-06-07 20:50:31', '2020-05-28 08:23:45');
INSERT INTO `sys_menu` VALUES ('45', '字典查看', '/sysDict/query', 'sys:dict:list', NULL, 'GET', '', '43', '', 0, 2, 0, 1, '2019-06-07 20:55:42', '2020-05-28 08:29:41');
INSERT INTO `sys_menu` VALUES ('46', '菜单查看', '/sysMenu/query', 'sys:menu:list', NULL, 'GET', '', '16', '', 0, 2, 0, 1, '2019-06-08 13:14:32', '2020-05-28 08:27:53');
INSERT INTO `sys_menu` VALUES ('47', '修改密码', '/sysUser/restPass/{id}', 'sys:user:updatePass', NULL, 'PUT', NULL, '2', NULL, 0, 2, 0, 1, '2019-06-15 09:43:20', '2020-05-28 08:21:54');
INSERT INTO `sys_menu` VALUES ('48', '修改邮箱', '/sysUser/updateEmail/{id}', 'sys:user:updateEmail', NULL, 'PUT', NULL, '2', NULL, 0, 2, 0, 1, '2019-06-15 09:43:58', '2020-05-28 08:21:56');
INSERT INTO `sys_menu` VALUES ('49', '用户列表', '/sysUser/query', 'sys:user:list', NULL, 'GET', NULL, '2', NULL, 0, 2, 0, 1, '2019-06-15 09:43:58', '2020-05-28 08:21:57');
INSERT INTO `sys_menu` VALUES ('5', '用户新增', '/sysUser/add', 'sys:user:add', NULL, 'POST', NULL, '2', NULL, 0, 2, 0, 1, '2019-04-22 13:09:11', '2020-05-28 08:21:48');
INSERT INTO `sys_menu` VALUES ('50', '开发文档', NULL, NULL, 'http://localhost:8081/swagger-ui.html#/', 'GET', '', '0', 'blogLink', 2, 0, 0, 0, '2019-06-18 18:31:18', '2020-05-28 08:09:15');
INSERT INTO `sys_menu` VALUES ('6', '系统管理', NULL, NULL, 'sys', 'GET', '', '0', 'sys', 1, 0, 0, 1, '2019-04-22 23:48:02', '2020-05-28 08:09:07');
INSERT INTO `sys_menu` VALUES ('7', '日志管理', NULL, NULL, 'log', 'GET', 'sys/log', '6', 'log', 0, 1, 0, 1, '2019-04-22 23:59:40', '2020-05-28 08:09:44');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '角色主键',
  `role_name` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '角色名称',
  `role_code` varchar(40) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色标识',
  `role_desc` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色描述',
  `dept_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门id',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '删除标识（0-正常,1-删除）',
  `ds_type` int(1) DEFAULT NULL COMMENT '数据权限类型',
  `ds_scope` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据权限范围 1 全部 2 本级 3 本级以及子级 4 自定义',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1271329722547085314', '啥啥啥111223333', '啥啥啥', 'aaa', '1268098678998016002', 0, 1, NULL, '2020-06-12 14:33:20', '2020-06-12 15:17:49');
INSERT INTO `sys_role` VALUES ('1271330461273071618', 'a\'a', 'a\'a\'a\'a', 'a\'a', '4', 0, 1, NULL, '2020-06-12 14:36:16', '2020-06-12 14:36:16');
INSERT INTO `sys_role` VALUES ('13', 'Rjdjd ', 'ddd', 'dd', '4', 0, 3, '6', '2019-06-16 00:35:32', '2020-06-12 14:21:58');
INSERT INTO `sys_role` VALUES ('5', '管理员', 'ADMIN_ROLE', '管理员', '4', 0, 1, '4,5,6,7,12', '2019-04-22 21:53:38', '2020-06-12 14:21:58');
INSERT INTO `sys_role` VALUES ('7', '开发人员', 'DEV_ROLE', '开发人员', '4', 0, 1, '2', '2019-04-24 21:11:28', '2020-06-12 14:21:59');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '部门主键ID',
  `role_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色ID',
  `dept_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色与部门对应关系';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_dept` VALUES ('100', '0', '5');
INSERT INTO `sys_role_dept` VALUES ('101', '0', '6');
INSERT INTO `sys_role_dept` VALUES ('102', '0', '7');
INSERT INTO `sys_role_dept` VALUES ('103', '0', '12');
INSERT INTO `sys_role_dept` VALUES ('104', '0', '4');
INSERT INTO `sys_role_dept` VALUES ('105', '0', '5');
INSERT INTO `sys_role_dept` VALUES ('106', '0', '6');
INSERT INTO `sys_role_dept` VALUES ('107', '0', '7');
INSERT INTO `sys_role_dept` VALUES ('108', '0', '12');
INSERT INTO `sys_role_dept` VALUES ('109', '0', '4');
INSERT INTO `sys_role_dept` VALUES ('110', '0', '5');
INSERT INTO `sys_role_dept` VALUES ('111', '0', '6');
INSERT INTO `sys_role_dept` VALUES ('112', '0', '7');
INSERT INTO `sys_role_dept` VALUES ('113', '0', '12');
INSERT INTO `sys_role_dept` VALUES ('119', '13', '6');
INSERT INTO `sys_role_dept` VALUES ('143', '5', '4');
INSERT INTO `sys_role_dept` VALUES ('144', '5', '5');
INSERT INTO `sys_role_dept` VALUES ('145', '5', '6');
INSERT INTO `sys_role_dept` VALUES ('146', '5', '7');
INSERT INTO `sys_role_dept` VALUES ('147', '5', '12');
INSERT INTO `sys_role_dept` VALUES ('47', '7', '6');
INSERT INTO `sys_role_dept` VALUES ('74', '0', '4');
INSERT INTO `sys_role_dept` VALUES ('75', '0', '5');
INSERT INTO `sys_role_dept` VALUES ('76', '0', '6');
INSERT INTO `sys_role_dept` VALUES ('77', '0', '7');
INSERT INTO `sys_role_dept` VALUES ('78', '0', '12');
INSERT INTO `sys_role_dept` VALUES ('99', '0', '4');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `role_id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '角色ID',
  `menu_id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`),
  KEY `index_role_id` (`role_id`) USING BTREE COMMENT '角色Id',
  KEY `index_menu_id` (`menu_id`) USING BTREE COMMENT '菜单Id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色菜单表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES ('1271330461298237442', '1271330461273071618', '1');
INSERT INTO `sys_role_menu` VALUES ('1271330461315014658', '1271330461273071618', '13');
INSERT INTO `sys_role_menu` VALUES ('1271330461323403265', '1271330461273071618', '15');
INSERT INTO `sys_role_menu` VALUES ('1271330461327597569', '1271330461273071618', '34');
INSERT INTO `sys_role_menu` VALUES ('1271330461331791873', '1271330461273071618', '37');
INSERT INTO `sys_role_menu` VALUES ('1271330461340180482', '1271330461273071618', '38');
INSERT INTO `sys_role_menu` VALUES ('1271330461340180483', '1271330461273071618', '16');
INSERT INTO `sys_role_menu` VALUES ('1271330461340180484', '1271330461273071618', '28');
INSERT INTO `sys_role_menu` VALUES ('1271330461344374786', '1271330461273071618', '29');
INSERT INTO `sys_role_menu` VALUES ('1271330461344374787', '1271330461273071618', '36');
INSERT INTO `sys_role_menu` VALUES ('1271330461344374788', '1271330461273071618', '46');
INSERT INTO `sys_role_menu` VALUES ('1271330461352763394', '1271330461273071618', '17');
INSERT INTO `sys_role_menu` VALUES ('1271330461352763395', '1271330461273071618', '39');
INSERT INTO `sys_role_menu` VALUES ('1271330461352763396', '1271330461273071618', '40');
INSERT INTO `sys_role_menu` VALUES ('1271330461352763397', '1271330461273071618', '41');
INSERT INTO `sys_role_menu` VALUES ('1271330461356957698', '1271330461273071618', '42');
INSERT INTO `sys_role_menu` VALUES ('1271330461356957699', '1271330461273071618', '2');
INSERT INTO `sys_role_menu` VALUES ('1271330461356957700', '1271330461273071618', '14');
INSERT INTO `sys_role_menu` VALUES ('1271330461356957701', '1271330461273071618', '33');
INSERT INTO `sys_role_menu` VALUES ('1271330461356957702', '1271330461273071618', '35');
INSERT INTO `sys_role_menu` VALUES ('1271330461356957703', '1271330461273071618', '47');
INSERT INTO `sys_role_menu` VALUES ('1271330461356957704', '1271330461273071618', '48');
INSERT INTO `sys_role_menu` VALUES ('1271330461356957705', '1271330461273071618', '49');
INSERT INTO `sys_role_menu` VALUES ('1271330461365346305', '1271330461273071618', '5');
INSERT INTO `sys_role_menu` VALUES ('1271330461365346306', '1271330461273071618', '3');
INSERT INTO `sys_role_menu` VALUES ('1271330461365346307', '1271330461273071618', '11');
INSERT INTO `sys_role_menu` VALUES ('1271330461373734914', '1271330461273071618', '30');
INSERT INTO `sys_role_menu` VALUES ('1271330461377929217', '1271330461273071618', '31');
INSERT INTO `sys_role_menu` VALUES ('1271330461386317825', '1271330461273071618', '44');
INSERT INTO `sys_role_menu` VALUES ('1271330461398900737', '1271330461273071618', '43');
INSERT INTO `sys_role_menu` VALUES ('1271330461398900738', '1271330461273071618', '45');
INSERT INTO `sys_role_menu` VALUES ('1271330461398900739', '1271330461273071618', '1271321271540461570');
INSERT INTO `sys_role_menu` VALUES ('1271330461411483650', '1271330461273071618', '1271322754440835074');
INSERT INTO `sys_role_menu` VALUES ('1271330461411483651', '1271330461273071618', '6');
INSERT INTO `sys_role_menu` VALUES ('1271330461411483652', '1271330461273071618', '18');
INSERT INTO `sys_role_menu` VALUES ('1271330461415677953', '1271330461273071618', '25');
INSERT INTO `sys_role_menu` VALUES ('1271330461415677954', '1271330461273071618', '26');
INSERT INTO `sys_role_menu` VALUES ('1271330461415677955', '1271330461273071618', '32');
INSERT INTO `sys_role_menu` VALUES ('1271330461415677956', '1271330461273071618', '7');
INSERT INTO `sys_role_menu` VALUES ('1271330461415677957', '1271330461273071618', '50');
INSERT INTO `sys_role_menu` VALUES ('1271340917584830465', '1271329722547085314', '1');
INSERT INTO `sys_role_menu` VALUES ('1271340917601607682', '1271329722547085314', '13');
INSERT INTO `sys_role_menu` VALUES ('1271340917601607683', '1271329722547085314', '15');
INSERT INTO `sys_role_menu` VALUES ('1271340917601607684', '1271329722547085314', '34');
INSERT INTO `sys_role_menu` VALUES ('1271340917605801985', '1271329722547085314', '37');
INSERT INTO `sys_role_menu` VALUES ('1271340917605801986', '1271329722547085314', '38');
INSERT INTO `sys_role_menu` VALUES ('1271340917605801987', '1271329722547085314', '16');
INSERT INTO `sys_role_menu` VALUES ('1271340917605801988', '1271329722547085314', '28');
INSERT INTO `sys_role_menu` VALUES ('1271340917605801989', '1271329722547085314', '29');
INSERT INTO `sys_role_menu` VALUES ('1271340917605801990', '1271329722547085314', '36');
INSERT INTO `sys_role_menu` VALUES ('1271340917605801991', '1271329722547085314', '46');
INSERT INTO `sys_role_menu` VALUES ('1271340917614190594', '1271329722547085314', '17');
INSERT INTO `sys_role_menu` VALUES ('1271340917614190595', '1271329722547085314', '39');
INSERT INTO `sys_role_menu` VALUES ('1271340917614190596', '1271329722547085314', '40');
INSERT INTO `sys_role_menu` VALUES ('1271340917614190597', '1271329722547085314', '41');
INSERT INTO `sys_role_menu` VALUES ('1271340917614190598', '1271329722547085314', '42');
INSERT INTO `sys_role_menu` VALUES ('1271340917614190599', '1271329722547085314', '2');
INSERT INTO `sys_role_menu` VALUES ('1271340917614190600', '1271329722547085314', '14');
INSERT INTO `sys_role_menu` VALUES ('1271340917614190601', '1271329722547085314', '33');
INSERT INTO `sys_role_menu` VALUES ('1271340917618384897', '1271329722547085314', '35');
INSERT INTO `sys_role_menu` VALUES ('1271340917618384898', '1271329722547085314', '47');
INSERT INTO `sys_role_menu` VALUES ('1271340917618384899', '1271329722547085314', '48');
INSERT INTO `sys_role_menu` VALUES ('1271340917618384900', '1271329722547085314', '49');
INSERT INTO `sys_role_menu` VALUES ('1271340917618384901', '1271329722547085314', '5');
INSERT INTO `sys_role_menu` VALUES ('1271340917622579202', '1271329722547085314', '3');
INSERT INTO `sys_role_menu` VALUES ('1271340917622579203', '1271329722547085314', '11');
INSERT INTO `sys_role_menu` VALUES ('1271340917622579204', '1271329722547085314', '30');
INSERT INTO `sys_role_menu` VALUES ('1271340917622579205', '1271329722547085314', '31');
INSERT INTO `sys_role_menu` VALUES ('1271340917622579206', '1271329722547085314', '44');
INSERT INTO `sys_role_menu` VALUES ('1271340917626773506', '1271329722547085314', '43');
INSERT INTO `sys_role_menu` VALUES ('1271340917626773507', '1271329722547085314', '45');
INSERT INTO `sys_role_menu` VALUES ('1271340917626773508', '1271329722547085314', '1271321271540461570');
INSERT INTO `sys_role_menu` VALUES ('1271340917626773509', '1271329722547085314', '1271322754440835074');
INSERT INTO `sys_role_menu` VALUES ('1271340917626773510', '1271329722547085314', '6');
INSERT INTO `sys_role_menu` VALUES ('1271340917630967810', '1271329722547085314', '18');
INSERT INTO `sys_role_menu` VALUES ('1271340917630967811', '1271329722547085314', '25');
INSERT INTO `sys_role_menu` VALUES ('1271340917630967812', '1271329722547085314', '26');
INSERT INTO `sys_role_menu` VALUES ('1271340917630967813', '1271329722547085314', '32');
INSERT INTO `sys_role_menu` VALUES ('1271340917630967814', '1271329722547085314', '7');
INSERT INTO `sys_role_menu` VALUES ('1271340917630967815', '1271329722547085314', '50');
INSERT INTO `sys_role_menu` VALUES ('1456', '7', '1');
INSERT INTO `sys_role_menu` VALUES ('1457', '7', '2');
INSERT INTO `sys_role_menu` VALUES ('1458', '7', '33');
INSERT INTO `sys_role_menu` VALUES ('1459', '7', '13');
INSERT INTO `sys_role_menu` VALUES ('1460', '7', '38');
INSERT INTO `sys_role_menu` VALUES ('1461', '7', '3');
INSERT INTO `sys_role_menu` VALUES ('1462', '7', '44');
INSERT INTO `sys_role_menu` VALUES ('1463', '7', '16');
INSERT INTO `sys_role_menu` VALUES ('1464', '7', '17');
INSERT INTO `sys_role_menu` VALUES ('1465', '7', '41');
INSERT INTO `sys_role_menu` VALUES ('1466', '7', '6');
INSERT INTO `sys_role_menu` VALUES ('1467', '7', '7');
INSERT INTO `sys_role_menu` VALUES ('1468', '7', '18');
INSERT INTO `sys_role_menu` VALUES ('1932', '5', '1');
INSERT INTO `sys_role_menu` VALUES ('1933', '5', '2');
INSERT INTO `sys_role_menu` VALUES ('1934', '5', '5');
INSERT INTO `sys_role_menu` VALUES ('1935', '5', '14');
INSERT INTO `sys_role_menu` VALUES ('1936', '5', '33');
INSERT INTO `sys_role_menu` VALUES ('1937', '5', '35');
INSERT INTO `sys_role_menu` VALUES ('1938', '5', '47');
INSERT INTO `sys_role_menu` VALUES ('1939', '5', '48');
INSERT INTO `sys_role_menu` VALUES ('1940', '5', '13');
INSERT INTO `sys_role_menu` VALUES ('1941', '5', '15');
INSERT INTO `sys_role_menu` VALUES ('1942', '5', '34');
INSERT INTO `sys_role_menu` VALUES ('1943', '5', '37');
INSERT INTO `sys_role_menu` VALUES ('1944', '5', '38');
INSERT INTO `sys_role_menu` VALUES ('1945', '5', '3');
INSERT INTO `sys_role_menu` VALUES ('1946', '5', '11');
INSERT INTO `sys_role_menu` VALUES ('1947', '5', '30');
INSERT INTO `sys_role_menu` VALUES ('1948', '5', '31');
INSERT INTO `sys_role_menu` VALUES ('1949', '5', '44');
INSERT INTO `sys_role_menu` VALUES ('1950', '5', '16');
INSERT INTO `sys_role_menu` VALUES ('1951', '5', '28');
INSERT INTO `sys_role_menu` VALUES ('1952', '5', '29');
INSERT INTO `sys_role_menu` VALUES ('1953', '5', '36');
INSERT INTO `sys_role_menu` VALUES ('1954', '5', '46');
INSERT INTO `sys_role_menu` VALUES ('1955', '5', '17');
INSERT INTO `sys_role_menu` VALUES ('1956', '5', '39');
INSERT INTO `sys_role_menu` VALUES ('1957', '5', '40');
INSERT INTO `sys_role_menu` VALUES ('1958', '5', '41');
INSERT INTO `sys_role_menu` VALUES ('1959', '5', '42');
INSERT INTO `sys_role_menu` VALUES ('1960', '5', '43');
INSERT INTO `sys_role_menu` VALUES ('1961', '5', '45');
INSERT INTO `sys_role_menu` VALUES ('1962', '5', '6');
INSERT INTO `sys_role_menu` VALUES ('1963', '5', '7');
INSERT INTO `sys_role_menu` VALUES ('1964', '5', '27');
INSERT INTO `sys_role_menu` VALUES ('1965', '5', '49');
INSERT INTO `sys_role_menu` VALUES ('1966', '5', '18');
INSERT INTO `sys_role_menu` VALUES ('1967', '5', '25');
INSERT INTO `sys_role_menu` VALUES ('1968', '5', '26');
INSERT INTO `sys_role_menu` VALUES ('1969', '5', '50');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `username` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
  `password` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '密码',
  `dept_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门ID',
  `job_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '岗位ID',
  `sex` tinyint(1) DEFAULT NULL COMMENT '性别（1：男 2：女）\n',
  `nick_name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '昵称\n',
  `qq` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'qq',
  `email` varchar(25) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号',
  `avatar` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像',
  `lock_flag` tinyint(1) DEFAULT '0' COMMENT '0-正常，1-锁定',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '0-正常，1-删除',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_idx_username` (`username`) USING BTREE,
  KEY `user_idx_dept_id` (`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1268090095631708161', 'vvvv', '$2a$10$oMBI0SBzBqIFE6jUkpvN6O0OZVv1OYa/4L.O2gXauH1/mGRY0sFyu', '7', NULL, NULL, NULL, NULL, 'qq1328312923@163.com', '15728046328', '', 0, 0, '2020-06-03 16:00:13', '2020-06-12 13:41:17');
INSERT INTO `sys_user` VALUES ('1268094911078576133', 'vvzdz', '$2a$10$7ipYxZdGA9dRB0JEjAEWeujv8pr9uFB/kGXsmUzjqss9YWtqAqI7q', '1268098678998016002', NULL, NULL, NULL, NULL, 'qq1328312923@163.com', '15728046329', '', 0, 0, '2020-06-03 16:19:21', '2020-06-12 13:40:58');
INSERT INTO `sys_user` VALUES ('1268095230416105474', 'vvzdz1q', '$2a$10$C7XB1lR6JfSfBEinUwjp5OJOz7aCrTg3tKvhCOHr/A1.eOjcVeD66', '4', '1', NULL, NULL, NULL, 'qq1328312923@163.com', '15728046319', '', 1, 0, '2020-06-03 16:20:37', '2020-06-11 10:46:27');
INSERT INTO `sys_user` VALUES ('1268096220397678594', 'vvvvv', '$2a$10$t3.PzKDZLdbm7Yj03qSheOu3UFAkZNft8gHBgg4NbZ0ktUftwLwZO', '4', NULL, NULL, NULL, NULL, 'qq1328312923@163.com', '15728056328', '', 1, 1, '2020-06-03 16:24:33', '2020-06-11 10:46:28');
INSERT INTO `sys_user` VALUES ('1271316697597423617', 'vvvvvvvv', '$2a$10$AB9.vHnmIS/RQbXiSnYKLeeajjvcOf2H1W/sYULv3y9mXSDazV/X.', '4', '1', NULL, NULL, NULL, 'qq1328312923q@163.com', '15728346328', '', 0, 0, '2020-06-12 13:41:35', '2020-06-12 13:41:35');
INSERT INTO `sys_user` VALUES ('4', 'admin', '$2a$10$JtrZUhxL15pyDRYFB86x1Or6jNN6PEKldP8fL7//uQ1y4f745mtQi', '6', '3', NULL, NULL, NULL, 'lihaodongmail@163.com', '17521296869', NULL, 1, 0, '2019-04-23 23:29:51', '2020-06-11 10:46:28');
INSERT INTO `sys_user` VALUES ('6', '小姐姐dev', '$2a$10$.WPow3X6iSC24vR9KDwXHew66tDgokxp73Oydh.KDqPsEI4zny6Ti', '6', '4', NULL, NULL, NULL, 'lihaodongmail@163.com', '17521296869', NULL, 0, 0, '2019-04-25 11:11:56', '2020-06-11 10:46:41');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `user_id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '用户ID',
  `role_id` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户角色表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('1270910119496986626', '1268095230416105474', '13');
INSERT INTO `sys_user_role` VALUES ('1271316587824099329', '1268094911078576133', '5');
INSERT INTO `sys_user_role` VALUES ('1271316622179643394', '1268090095631708161', '5');
INSERT INTO `sys_user_role` VALUES ('1271316697622589441', '1271316697597423617', '5');
INSERT INTO `sys_user_role` VALUES ('40', '4', '5');
INSERT INTO `sys_user_role` VALUES ('53', '6', '7');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
